access equivalent to Text function

jscranton

Well-known Member
Joined
May 30, 2011
Messages
707
I have a db filed with numbers stored as strings. I need to convert them to 9 characters but some had their leading zeroes trimmed off at some point.

So, 012345678 became 12345678.

I would normally do Text(stringHere,"000000000") to convert this in Excel.

Is there an equivalent function in Access?

Thanks,

Justin
 

Some videos you may like

Excel Facts

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"

Watch MrExcel Video

Forum statistics

Threads
1,096,305
Messages
5,449,565
Members
405,571
Latest member
Flux1234

This Week's Hot Topics

Top