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

What did Pito Salas invent?
Pito Salas, working for Lotus, popularized what would become to be pivot tables. It was released as Lotus Improv in 1989.

Watch MrExcel Video

Forum statistics

Threads
1,096,319
Messages
5,449,680
Members
405,574
Latest member
Masimo85

This Week's Hot Topics

Top