ExcelBanter - Two Formats for One Cell

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - Two Formats for One Cell (https://www.excelbanter.com/new-users-excel/138208-two-formats-one-cell.html)

Ivy

Two Formats for One Cell

Is it possible to have two formats in one cell. I have a column in which
dates or decimal points will need to be keyed (ex. 20070301 or 0.00)?

--
Ivy

JE McGimpsey

Two Formats for One Cell

One way:

Format/Cells/Number/Custom

[=19000000]00000000;[<19000000]0.00;General

In article ,
Ivy wrote:

Is it possible to have two formats in one cell. I have a column in which
dates or decimal points will need to be keyed (ex. 20070301 or 0.00)?

--
Ivy

All times are GMT +1. The time now is 08:44 AM.