Need code to change row that is formatted as text to be number with no decimals

kjicha

New Member
Joined
Feb 29, 2016
Messages
41
Currently in column A on my sheet in Excel 2013, my cells are formatted as text. So when I put a number in there I get a warning that this is a text field and I should convert the field to a number field.

How can I do this so that when I just open the worksheet it is already formatted like this? Thank you.
 

Some videos you may like

Excel Facts

Is there a shortcut key for strikethrough?
Ctrl+S is used for Save. Ctrl+5 is used for Strikethrough. Why Ctrl+5? When you use hashmarks to count |||| is 4, strike through to mean 5.

wornhall

Board Regular
Joined
Feb 16, 2016
Messages
60
You can start each number with a single quote, " ' ", or reformat the row to numeric; text entries are permitted there. Numbers will be right aligned and text to the left.
 

kjicha

New Member
Joined
Feb 29, 2016
Messages
41
Thank you. I actually had to change a macro that I had that was changing column A to text when ran. Thank you for the response.
 
Last edited:

Watch MrExcel Video

Forum statistics

Threads
1,099,052
Messages
5,466,277
Members
406,474
Latest member
osama beskales

This Week's Hot Topics

Top