MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Short Cut Key for Number Format

Posted by Craig on November 06, 2001 6:06 AM

Is anyone aware of a short cut key to enter a number AS IS into a cell.

i.e. you enter 012 and it converts to 12
I know you can format the cell to take the number as text but I want a shortcut key to take it directly.

I am aware of the Ctrl+Shift+! cut - that's not what I'm looking for.

Any help is GREATLY appreciated.

Posted by Mark W. on November 06, 2001 6:11 AM

Excel doesn't store numeric values with leading zeroes (nt)